package com.example.tms.mapper;


import com.example.tms.bean.PeakwaybillView;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * 高峰业务
 */
@Repository
public interface PeakwaybillVMapper  extends JpaSpecificationExecutor<PeakwaybillView>, JpaRepository<PeakwaybillView,String> {

    //查询所有区域
    @Query(value = "select distinct quyu from peak", nativeQuery = true)
    List<String> findQuyu();

    //查询所有其它区域
    @Query(value = "select distinct qyqt from peak", nativeQuery = true)
    List<String> findQyqt();
}
